package com.itheima.mapper;

import com.itheima.VO.ReportDataVO;
import com.itheima.pojo.ReportData;
import com.itheima.pojo.SetmealCount;
import org.apache.ibatis.annotations.Mapper;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;

@Mapper
public interface ReportMapper {
    List<String> selectRegTimeList();

    List<String> selectSetmealNames();

    List<Integer> selectIds();

    Integer selectCountBySetmealId(Integer setmealId);

    String selectSetmealNameById(Integer setmealId);

    List<ReportData> selectReportData();

//    ReportDataVO getBusinessReportData();

    Integer selectTodayVisitsNumber(LocalDateTime beginTime, LocalDateTime endTime);

    Integer selectTodayNewMember(LocalDateTime beginTime, LocalDateTime endTime);

    Integer selectThisWeekNewMember(Date beginWeekTime, Date endWeekTime);

    Integer selectThisMonthNewMember(Date beginMonthTime, Date endMonthTime);

    Integer selectThisWeekVisitsNumber(Date beginWeekTime, Date endWeekTime);

    Integer selectTotalMember();

    Integer selectThisMonthOrderNumber(Date beginMonthTime, Date endMonthTime);

    Integer selectThisMonthVisitsNumber(Date beginMonthTime, Date endMonthTime);

    Integer selectTodayOrderNumber(LocalDateTime beginTime, LocalDateTime endTime);

    Integer selectThisWeekOrderNumber(Date beginWeekTime, Date endWeekTime);
}
